UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5u1Y3/zHAkrB1OTHnzFLJOdLsh7EDmiI89fwQG9Xnsw='
WHERE
key_id = '3c0500dc9c612d27a52ecbc4bdbbde84b5480e2aeebabe303f057d934176049f'
AND (
token = '5u1Y3/zHAkrB1OTHnzFLJOdLsh7EDmiI89fwQG9Xnsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)