UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/0GwHmr7KBIeWoi7wjuWV7TU7UTcZguGYsYrtpjVpdI='
WHERE
key_id = '6fa631cee9316a2b2f4a405dd3540f4d20be4a5cac6f55379f7548b302a2cad9'
AND (
token = '/0GwHmr7KBIeWoi7wjuWV7TU7UTcZguGYsYrtpjVpdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)