UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wNvxPWFJJ3O9+LC46Q7A/Jf1kJ/tbFyXgM4/LlIykkY='
WHERE
key_id = '7112a6717a435617c344f425246c8fd8ff1560bee9d0e159868a5cc7bba89d78'
AND (
token = 'wNvxPWFJJ3O9+LC46Q7A/Jf1kJ/tbFyXgM4/LlIykkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)