UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lKVEXGXvmZgzk2y8J5hGkDKu7b5QfEBvZ1/hvM3tSB0='
WHERE
key_id = '042b0d31d8a70decf05568888b67c473c5fad5951e00c84ed8bbc9a10fd19463'
AND (
token = 'lKVEXGXvmZgzk2y8J5hGkDKu7b5QfEBvZ1/hvM3tSB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)