UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BTBdDyWneXYzha5FG13DR54uKZg0+f0O0Npucok64PY='
WHERE
key_id = 'c84eb147be8e80cf86da23382fb8581ca68f7999e618693ceabad8968a8ec86e'
AND (
token = 'BTBdDyWneXYzha5FG13DR54uKZg0+f0O0Npucok64PY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)