UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O47/vsFAh4/U+Yja1li89xAPGPNn4kfuwqmlz9hvfrE='
WHERE
key_id = '6e9850384e8e31e8371c57fc2aa88e265147ee0879c6b8f8a054d1ae8719f273'
AND (
token = 'O47/vsFAh4/U+Yja1li89xAPGPNn4kfuwqmlz9hvfrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)