UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WkxZBcyEV35nrB2Wf3g4T8+MCjlL2EloF26QvTYRHxo='
WHERE
key_id = 'c0a99074b957bdbba0e1042a94660e789ecc12410e94a712f6b6a5f07be50553'
AND (
token = 'WkxZBcyEV35nrB2Wf3g4T8+MCjlL2EloF26QvTYRHxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)