UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQVC4L0ICHjJcuDuy0QXNmilMNKHGuusTRvjabafpG4='
WHERE
key_id = 'f98f88c5ef3b1000817496cd450d9dcacc983887d603b0d04bf6fc0566ce2255'
AND (
token = 'ZQVC4L0ICHjJcuDuy0QXNmilMNKHGuusTRvjabafpG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)