UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQrAdR+KQO7ZTfyJi/mpA5F+zgE7+iAK987/1Yw6gzM='
WHERE
key_id = '489c15551df67b851d0bf0492a3b2c5f4686f124c7d38b61da00437ac840657a'
AND (
token = 'gQrAdR+KQO7ZTfyJi/mpA5F+zgE7+iAK987/1Yw6gzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)