UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ifYfCvSEcyQvX5qa7gKFHMfzMLI9HXSVEoN234sxES0='
WHERE
key_id = '494a04ff2f51686a33e36549643106acd3efc551d72142a860fbbaa71b623f87'
AND (
token = 'ifYfCvSEcyQvX5qa7gKFHMfzMLI9HXSVEoN234sxES0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)