UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8xT0jDpegRiHHH5M8YLztSWuU18NYKIsh3I4ZymOZfA='
WHERE
key_id = '7823ed0f4a75e5c32ad8af9fb49f650b0da5cc52c73cf42b313977fe903a1dd6'
AND (
token = '8xT0jDpegRiHHH5M8YLztSWuU18NYKIsh3I4ZymOZfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)