UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HrNq9UNKsOGiziotEpjWGO0nQwj7y7jfFocqL5H+2ec='
WHERE
key_id = 'dc93a83f62fcdfbbabfadc0d22c94ec5f9a0c7922e0e2e951281ae5d38b3b649'
AND (
token = 'HrNq9UNKsOGiziotEpjWGO0nQwj7y7jfFocqL5H+2ec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)