UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e1p+awrPqS6lUW+cEfAul7aGqfAPjgEI0E8nGYpVrGg='
WHERE
key_id = 'cf83599ebcb463585b1740dafd9cac94cdd2a5895b4dc7110cb9aef026b1904c'
AND (
token = 'e1p+awrPqS6lUW+cEfAul7aGqfAPjgEI0E8nGYpVrGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)