UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7uV47tn9Z1jXNaGUSySg5wwkAWlJ9StdrTXO4YhnAwI='
WHERE
key_id = '34c06969e2dee6143d69077e42724b9689edced4c1be3f355838d040dd7e4a95'
AND (
token = '7uV47tn9Z1jXNaGUSySg5wwkAWlJ9StdrTXO4YhnAwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)