UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UAeCMoeMN8IEZjKqyUa/wDAyi/9COUyYYKfHgPSeo0M='
WHERE
key_id = '5f87379a9c41f091129ad6ef5cc751dcd8f22c213749cafb4a3bd787b1345859'
AND (
token = 'UAeCMoeMN8IEZjKqyUa/wDAyi/9COUyYYKfHgPSeo0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)