UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZXRXpeMOPwuSm86qyhw8QXr/pwOm4jofx6I7xr12080='
WHERE
key_id = 'e8322a08ed74131a0df6888c033900fc76a21db3be73b531fe0f558cf794ba29'
AND (
token = 'ZXRXpeMOPwuSm86qyhw8QXr/pwOm4jofx6I7xr12080='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)