UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fiiEyU7a+Jrfr300WZ6d6EiGh02R41Q3YFMTIs3VFyY='
WHERE
key_id = 'e7146606a57caff71592375a7fb0c124c6effe27ea5fa575a8684740b3123ae8'
AND (
token = 'fiiEyU7a+Jrfr300WZ6d6EiGh02R41Q3YFMTIs3VFyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)