UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a9gn3rG7scbM/fe2iB2RkZtQHhI6Hijk5UwyXHvDPas='
WHERE
key_id = '9936ba746332eb8baf3811173ad4a43a8596aa53e740be0d19fc1e0f2935ca93'
AND (
token = 'a9gn3rG7scbM/fe2iB2RkZtQHhI6Hijk5UwyXHvDPas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)