UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4loXUnzdJKjcHUYzBKBL4fVCcS1Sykm3g87FRmh82mU='
WHERE
key_id = '4f38eac97e2dceabdb5a3d91b0109f00566bff2ef5c1faa97453461419ebe4de'
AND (
token = '4loXUnzdJKjcHUYzBKBL4fVCcS1Sykm3g87FRmh82mU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)