UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ZwpXIjFjj78T96piUUHSBWZIdjJQ2Xqc9kUe0k2UCo='
WHERE
key_id = '1a852f233b146a18945e0a34b2a8f37c44704c9f5e78023e52dd42a4f9508a54'
AND (
token = '2ZwpXIjFjj78T96piUUHSBWZIdjJQ2Xqc9kUe0k2UCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)