UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7XhRAvevB9tvvA9gZ739J5SbTJT+JfOQpbOfHWp6oEU='
WHERE
key_id = '195307cc83bddd2e8edc87d2b54c22e87594a5a1f3f3815c74a7ea1055b38bc9'
AND (
token = '7XhRAvevB9tvvA9gZ739J5SbTJT+JfOQpbOfHWp6oEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)