UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/lsogZ+et2tyc9p6/95bKTN4+63J/bAbbyPwkHgPosU='
WHERE
key_id = 'd7c808f095c31c4821642763cfae10dc933aff6bb5dc3f46574aa4b5e140f256'
AND (
token = '/lsogZ+et2tyc9p6/95bKTN4+63J/bAbbyPwkHgPosU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)