UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '678PLMUfQXe6O2EhPF1rjeyWgV/N7EE6Cu1snHbeUyc='
WHERE
key_id = '123bd851ebfd3ea3eab9cf4fa84a5de90c06553062f7c74b3152e92c03c8301b'
AND (
token = '678PLMUfQXe6O2EhPF1rjeyWgV/N7EE6Cu1snHbeUyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)