UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Ll0QM6ejaYsAnJeR5atVyI06tEz4/PQO6VhqFHA8yA='
WHERE
key_id = '54894917ba9b031df7960ad0737ef5204d31775403dde3e99e71b6c8eb9c36f5'
AND (
token = '0Ll0QM6ejaYsAnJeR5atVyI06tEz4/PQO6VhqFHA8yA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)