UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YKy4oqy8ujnQanBr1B6+9+xghwmMDLeub2+Ock1QNP0='
WHERE
key_id = '1e09744efbfb4f66d4c54594a5c6414ab73a15737bbb1d1b67e62be894731170'
AND (
token = 'YKy4oqy8ujnQanBr1B6+9+xghwmMDLeub2+Ock1QNP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)