UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vEi4pv53c/0ButFfLtwmDr+6/7QfDfLeCgdNUPY72PY='
WHERE
key_id = '497bc91ace70247b52bf6b67a1d8020d0c3233bd958f65731f32fcf38a5fc163'
AND (
token = 'vEi4pv53c/0ButFfLtwmDr+6/7QfDfLeCgdNUPY72PY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)