UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oPprcK4bSAq0GIl71EPWUPZpMG2mb8AqKF8qpfsSO+k='
WHERE
key_id = '30bfb7f11a607390fafa2dd93d9fff7c530f8cf719185af5195e2bbe05ba7553'
AND (
token = 'oPprcK4bSAq0GIl71EPWUPZpMG2mb8AqKF8qpfsSO+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)