UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/SSCvJxLw1Rct7XoNlyIc+2rWx1hwnA2IGMbGYdCz4U='
WHERE
key_id = 'fc46ab80711dcefca9e62ecb58e00e12215291d29e3980f32131e6f5a56b1c5e'
AND (
token = '/SSCvJxLw1Rct7XoNlyIc+2rWx1hwnA2IGMbGYdCz4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)