UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qbn1ffGnSjHVSQPkJNqv+PHOdjzzqabUHKUP0Lqa3gw='
WHERE
key_id = 'a154d6e397664e064a8b5a8fbf3c7eb031dabfd3ae5ccd1d90c6f7da72408bd6'
AND (
token = 'Qbn1ffGnSjHVSQPkJNqv+PHOdjzzqabUHKUP0Lqa3gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)