UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gkL0N5E05CzzVtFFLKUnYC2YbO2ecFyQ/4p8kaupRUI='
WHERE
key_id = 'd7f4a6cc808b745462cdddae81bc44d3c05ebeaae03e7cc12824d7f33f83c637'
AND (
token = 'gkL0N5E05CzzVtFFLKUnYC2YbO2ecFyQ/4p8kaupRUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)