UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7rRyxycl+TS2kzh/bS16Lrhmu7+YNCNCImXq5zGTwP8='
WHERE
key_id = '92b87e93fd188631e566df80f5affec6e292d1743f7c22c446fca528620b2c37'
AND (
token = '7rRyxycl+TS2kzh/bS16Lrhmu7+YNCNCImXq5zGTwP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)