UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zzkbV2sPlGOICJR0wluzSl8Nx2rPCL7+bF0LGKhrhs='
WHERE
key_id = 'd0dcac13182a01bf4e063e9f727ea4a419473d3bccca8da5ebf2e0ee9c897701'
AND (
token = '6zzkbV2sPlGOICJR0wluzSl8Nx2rPCL7+bF0LGKhrhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)