UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cK1OrH1eNaruRdqvglfpMrOApMp5Rf+1RwpsVsKOqWw='
WHERE
key_id = 'e5ee10a03dbf0afc5aae7fb9e897ce9e62439cf4294de813854ce676c94960cb'
AND (
token = 'cK1OrH1eNaruRdqvglfpMrOApMp5Rf+1RwpsVsKOqWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)