UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DlE6Cm3Ebug2NrbdR80ijwNRxkS1DCTulvvBhRz24hM='
WHERE
key_id = 'b9f9136132f31ec5936f709cf02b512546a03d7658d8db91c2827808a7ca3cab'
AND (
token = 'DlE6Cm3Ebug2NrbdR80ijwNRxkS1DCTulvvBhRz24hM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)