UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y4sQcPDdED9C9ojIUoYa3WuFv2bLquHYy477rttgRl0='
WHERE
key_id = '3e0feca0f56763799ee825ed66a3defa96dc2f0ea06bfca5604534fb4cd0cace'
AND (
token = 'y4sQcPDdED9C9ojIUoYa3WuFv2bLquHYy477rttgRl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)