UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bYOAjsogdXzVj+Ke9LMvaXkdMU0hCen0J3QUN5+KUMU='
WHERE
key_id = 'be3451e39d26312c87035934ac60657c9a9e1828c6faa42e9492b6c954b49163'
AND (
token = 'bYOAjsogdXzVj+Ke9LMvaXkdMU0hCen0J3QUN5+KUMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)