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